﻿using System;

namespace edowork.com.Model
{
    #region onroad_inventory_logInfo

    [Serializable]
    public class onroad_inventory_logInfo
    {
        #region Private fields

        protected string _billsno = String.Empty;
        protected string _productcode = String.Empty;
        protected decimal _qty;
        protected DateTime _sysdate;

        #endregion

        public onroad_inventory_logInfo() { }

        #region Public Properties

        public string Billsno
        {
            get { return _billsno; }
            set { _billsno = value; }
        }

        public string Productcode
        {
            get { return _productcode; }
            set { _productcode = value; }
        }

        public decimal Qty
        {
            get { return _qty; }
            set { _qty = value; }
        }

        public DateTime Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into onroad_inventory_log(Billsno,Productcode,Qty,Sysdate) values('{0}','{1}',{2},{3})";
        }

        #endregion

    }

    #endregion
}

